Search Results for: "SIG P320 XTEN"

The Sig Sauer Store
The Sig Sauer Store
Shop now
Sig Sauer Brand Store
357 SIG 125 GR HST JHP 20/BOX

Federal 357 Sig 125 gr JHP HST 20/Box

357 SIG 125 GR JHP POLICE TRADE AMMO 50/BOX

Federal 357 Sig 125 gr JHP HST Police Trade Ammo 50/Box

Debugging Information
ColdFusion Server Evaluation 2021,0,13,330286
Template /search.cfm
Time Stamp 20-May-24 02:36 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.200.2.4
Host Name 10.200.2.4

Execution Time

Total Time Avg Time Count Template
1015 ms 1015 ms 1 E:/inetpub/wwwroot/search.cfm
32 ms 16 ms 2 C:/inetpub/wwwroot/includes/dropship.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/includes/brands.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/metatags.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/newfooter.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/newheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/of3.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/security/block_access.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/security/library.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/includes/security/sql_injection.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/Application.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/pagethru.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/search_sidenav.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1015 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

redirects (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 14:36:41.041
select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='SIG P320 XTEN' and kword <> '' and kword is not NULL and site='sportsman'
mysearch (Datasource=celerantsql, Time=823ms, Records=2) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
SELECT distinct a.style_id,
 case a.style_id 
 
 when 283411 then 1 
 when 298434 then 2 
 when 281486 then 3 
 when 293144 then 4 
 when 289734 then 5 
 when 298681 then 6 
 when 287949 then 7 
 when 191697 then 8 
 when 189567 then 9 
 when 162540 then 10 
 when 249453 then 11 
 when 193375 then 12 
 when 168069 then 13 
 when 168070 then 14 
 when 170724 then 15 
 when 141427 then 16 
 when 155227 then 17 
 when 155229 then 18 
 when 155228 then 19 
 when 168068 then 20 
 when 168071 then 21 
 when 188991 then 22 
 when 189589 then 23 
 when 189787 then 24 
 when 144265 then 25 
 when 162541 then 26 
 when 268154 then 27 
 when 191500 then 28 
 when 189580 then 29 
 when 197445 then 30 
 when 217128 then 31 
 when 289719 then 32 
 when 289714 then 33 
 when 215964 then 34 
 when 217129 then 35 
 when 253368 then 36 
 when 264484 then 37 
 when 191499 then 38 
 when 219792 then 39 
 when 193408 then 40 
 when 227545 then 41 
 when 214489 then 42 
 when 217212 then 43 
 when 246380 then 44 
 when 188134 then 45 
 when 277967 then 46 
 when 262983 then 47 
 when 181408 then 48 
 when 214889 then 49 
 when 246384 then 50 
 when 246403 then 51 
 when 246407 then 52 
 when 291472 then 53 
 when 218468 then 54 
 when 138436 then 55 
 when 138438 then 56 
 when 165464 then 57 
 when 205360 then 58 
 when 152843 then 59 
 when 152845 then 60 
 when 209942 then 61 
 when 218178 then 62 
 when 217905 then 63 
 when 268755 then 64 
 when 138432 then 65 
 when 201609 then 66 
 when 205173 then 67 
 when 202476 then 68 
 when 201657 then 69 
 when 138431 then 70 
 when 138434 then 71 
 when 250203 then 72 
 when 250200 then 73 
 when 264644 then 74 
 when 283475 then 75 
 when 222100 then 76 
 when 267937 then 77 
 when 251088 then 78 
 when 228147 then 79 
 when 228144 then 80 
 when 228141 then 81 
 when 263215 then 82 
 when 253555 then 83 
 when 89606 then 84 
 when 207504 then 85 
 when 282862 then 86 
 when 222482 then 87 
 when 222333 then 88 
 when 207474 then 89 
 when 207505 then 90 
 when 216276 then 91 
 when 260512 then 92 
 when 277237 then 93 
 when 277234 then 94 
 when 250687 then 95 
 when 222485 then 96 
 when 280745 then 97 
 when 278752 then 98 
 when 217904 then 99 
 when 275836 then 100 
 when 287890 then 101 
 when 263211 then 102 
 when 278754 then 103 
 when 301548 then 104 
 when 201655 then 105 
 when 282227 then 106 
 when 170821 then 107 
 when 247846 then 108 
 when 210846 then 109 
 when 189594 then 110 
 when 228150 then 111 
 when 278753 then 112 
 when 278755 then 113 
 when 305651 then 114 
 when 300611 then 115 
 when 308275 then 116 
 when 201650 then 117 
 when 196812 then 118 
 when 208933 then 119 
 when 278367 then 120 
 when 201674 then 121 
 when 303755 then 122 
 when 209601 then 123 
 when 198548 then 124 
 when 250397 then 125 
 when 277235 then 126 
 when 252130 then 127 
 when 151846 then 128 
 when 193386 then 129 
 when 201654 then 130 
 when 201651 then 131 
 when 201652 then 132 
 when 210121 then 133 
 when 283392 then 134 
 when 210635 then 135 
 when 298167 then 136 
 when 277062 then 137 
 when 297384 then 138 
 when 299070 then 139 
 when 289116 then 140 
 when 289117 then 141 
 when 175432 then 142 
 when 15129 then 143 
 when 217649 then 144 
 when 155226 then 145 
 when 179687 then 146 
 when 206179 then 147 
 when 148343 then 148 
 when 285113 then 149 
 when 298165 then 150 
 when 285431 then 151 
 when 251882 then 152 
 when 164239 then 153 
 when 144144 then 154 
 when 149189 then 155 
 when 138435 then 156 
 when 204907 then 157 
 when 264091 then 158 
 when 206457 then 159 
 when 297582 then 160 
 when 153211 then 161 
 when 165466 then 162 
 when 206670 then 163 
 when 152842 then 164 
 when 282761 then 165 
 when 201653 then 166 
 when 162542 then 167 
 when 247848 then 168 
 when 252883 then 169 
 when 206460 then 170 
 when 170725 then 171 
 when 170723 then 172 
 when 293051 then 173 
 when 301850 then 174 
 when 298961 then 175 
 when 277966 then 176 
 when 282760 then 177 
 when 282285 then 178 
 when 138437 then 179 
 when 152854 then 180 
 when 207091 then 181 
 when 207092 then 182 
 when 205179 then 183 
 when 196302 then 184 
 when 205664 then 185 
 when 271030 then 186 
 when 271312 then 187 
 when 155230 then 188 
 when 193230 then 189 
 when 165470 then 190 
 when 228095 then 191 
 when 202810 then 192 
 when 161617 then 193 
 when 214887 then 194 
 when 289737 then 195 
 when 206466 then 196 
 when 271313 then 197 
 when 198217 then 198 
 when 152849 then 199 
 when 196303 then 200 
 when 138433 then 201 
 when 217768 then 202 
 when 220209 then 203 
 when 268663 then 204 
 when 233710 then 205 
 when 303799 then 206 
 when 161216 then 207 
 when 204908 then 208 
 when 175958 then 209 
 when 206456 then 210 
 when 277970 then 211 
 when 289677 then 212 
 when 289679 then 213 
 when 218104 then 214 
 when 247847 then 215 
 when 277239 then 216 
 when 289695 then 217 
 when 201710 then 218 
 when 302194 then 219 
 when 280000 then 220 
 when 280841 then 221 
 when 291634 then 222 
 when 203393 then 223 
 when 203323 then 224 
 when 267507 then 225 
 when 274250 then 226 
 when 286482 then 227 
 when 215561 then 228 
 when 219943 then 229 
 when 261953 then 230 
 when 261985 then 231 
 when 206461 then 232 
 when 250716 then 233 
 when 145597 then 234 
 when 263040 then 235 
 when 179265 then 236 
 when 209440 then 237 
 when 256250 then 238 
 when 275904 then 239 
 when 206464 then 240 
 when 279691 then 241 
 when 303580 then 242 
 when 218177 then 243 
 when 202845 then 244 
 when 222478 then 245 
 when 249450 then 246 
 when 246991 then 247 
 when 245230 then 248 
 when 255173 then 249 
 when 260776 then 250 
 when 249582 then 251 
 when 251036 then 252 
 when 218176 then 253 
 when 250204 then 254 
 when 263864 then 255 
 when 283415 then 256 
 when 290906 then 257 
 when 292810 then 258 
 when 262972 then 259 
 when 198667 then 260 
 when 189449 then 261 
 when 218505 then 262 
 when 206330 then 263 
 when 271308 then 264 
 when 276309 then 265 
 when 218175 then 266 
 when 218179 then 267 
 when 220298 then 268 
 when 251881 then 269 
 when 263829 then 270 
 when 263367 then 271 
 when 277236 then 272 
 when 289884 then 273 
 when 202846 then 274 
 when 209505 then 275 
 when 216504 then 276 
 when 250205 then 277 
 when 247442 then 278 
 when 279438 then 279 
 when 206463 then 280 
 when 303745 then 281 
 when 296697 then 282 
 when 173214 then 283 
 when 206437 then 284 
 when 176103 then 285 
 when 264483 then 286 
 when 277238 then 287 
 when 277240 then 288 
 when 285139 then 289 
 when 246436 then 290 
 when 283943 then 291 
 when 283942 then 292 
 when 166588 then 293 
 when 225817 then 294 
 when 302950 then 295 
 when 293485 then 296 
 when 217242 then 297 
 when 89297 then 298 
 when 162546 then 299 
 when 162544 then 300 
 when 277982 then 301 
 when 277978 then 302 
 when 159446 then 303 
 when 182571 then 304 
 when 175868 then 305 
 when 161619 then 306 
 when 262985 then 307 
 when 262967 then 308 
 when 279773 then 309 
 when 277985 then 310 
 when 215820 then 311 
 when 246435 then 312 
 when 248245 then 313 
 when 260511 then 314 
 when 161513 then 315 
 when 198663 then 316 
 when 277984 then 317 
 when 279778 then 318 
 when 279451 then 319 
 when 250649 then 320 
 when 271311 then 321 
 when 167796 then 322 
 when 159445 then 323 
 when 198664 then 324 
 when 198665 then 325 
 when 181370 then 326 
 when 279439 then 327 
 when 198666 then 328 
 when 262984 then 329 
 when 297430 then 330 
 when 249468 then 331 
 when 262952 then 332 
 when 277983 then 333 
 when 249470 then 334 
 when 249467 then 335 
 when 89610 then 336 
 when 302968 then 337 
 when 175138 then 338 
 when 247885 then 339 
 when 279776 then 340 
 when 279777 then 341 
 when 206470 then 342 
 when 262957 then 343 
 when 89299 then 344 
 when 206471 then 345 
 when 222120 then 346 
 when 262958 then 347 
 when 262959 then 348 
 when 262962 then 349 
 when 250831 then 350 
 when 267283 then 351 
 when 282992 then 352 
 when 277976 then 353 
 when 301227 then 354 
 when 277977 then 355 
 when 262449 then 356 
 when 250757 then 357 
 when 262966 then 358 
 when 246428 then 359 
 when 208907 then 360 
 when 301228 then 361 
 when 267284 then 362 
 when 279692 then 363 
 when 249471 then 364 
 when 249472 then 365 
 when 249474 then 366 
 when 255633 then 367 
 when 276248 then 368 
 when 210644 then 369 
 when 249473 then 370 
 when 255635 then 371 
 when 296377 then 372 
 when 289702 then 373 
 when 283941 then 374 
 when 284839 then 375 
 when 279452 then 376 
 when 297425 then 377 
 when 263257 then 378 
 when 262393 then 379 
 when 252962 then 380 
 when 16344 then 381 
 when 262396 then 382 
 when 262395 then 383 
 when 255636 then 384 
 when 170687 then 385 
 when 152691 then 386 
 when 77821 then 387 
 when 133210 then 388 
 when 152694 then 389 
 when 123538 then 390 
 when 157927 then 391 
 when 179487 then 392 
 when 249851 then 393 
 when 217916 then 394 
 when 282168 then 395 
 when 92454 then 396 
 when 148134 then 397 
 when 71050 then 398 
 when 277781 then 399 
 when 126635 then 400 
 when 198832 then 401 
 when 213381 then 402 
 when 213380 then 403 
 when 216928 then 404 
 when 79756 then 405 
 when 202779 then 406 
 when 277941 then 407 
 when 125460 then 408 
 when 111737 then 409 
 when 125108 then 410 
 when 149613 then 411 
 when 205253 then 412 
 when 202782 then 413 
 when 262948 then 414 
 when 279326 then 415 
 when 70300 then 416 
 when 119542 then 417 
 when 113481 then 418 
 when 113490 then 419 
 when 86578 then 420 
 when 114111 then 421 
 when 116423 then 422 
 when 118138 then 423 
 when 170697 then 424 
 when 175615 then 425 
 when 94966 then 426 
 when 285809 then 427 
 when 95789 then 428 
 when 123105 then 429 
 when 78406 then 430 
 when 79229 then 431 
 when 115921 then 432 
 when 158537 then 433 
 when 170682 then 434 
 when 181371 then 435 
 when 204074 then 436 
 when 48126 then 437 
 when 211036 then 438 
 when 217217 then 439 
 when 214888 then 440 
 when 215812 then 441 
 when 64020 then 442 
 when 134509 then 443 
 when 195486 then 444 
 when 89614 then 445 
 when 147942 then 446 
 when 260980 then 447 
 when 267905 then 448 
 when 114838 then 449 
 when 291094 then 450 
 when 291168 then 451 
 when 204050 then 452 
 when 56316 then 453 
 when 288154 then 454 
 when 103823 then 455 
 when 79755 then 456 
 when 86480 then 457 
 when 86560 then 458 
 when 87024 then 459 
 when 118320 then 460 
 when 163768 then 461 
 when 191731 then 462 
 when 195484 then 463 
 when 217906 then 464 
 when 219944 then 465 
 when 47985 then 466 
 when 251969 then 467 
 when 266700 then 468 
 when 262986 then 469 
 when 131401 then 470 
 when 189701 then 471 
 when 210647 then 472 
 when 264694 then 473 
 when 121353 then 474 
 when 7562 then 475 
 when 121689 then 476 
 when 217903 then 477 
 when 202783 then 478 
 when 87888 then 479 
 when 133695 then 480 
 when 85710 then 481 
 when 116293 then 482 
 when 120430 then 483 
 when 135513 then 484 
 when 95332 then 485 
 when 129534 then 486 
 when 132580 then 487 
 when 138447 then 488 
 when 155772 then 489 
 when 47992 then 490 
 when 157716 then 491 
 when 170661 then 492 
 when 183755 then 493 
 when 199042 then 494 
 when 206669 then 495 
 when 205240 then 496 
 when 249691 then 497 
 when 251526 then 498 
 when 208034 then 499 
 when 105742 then 500 
 when 111008 then 501 
 when 107091 then 502 
 when 89696 then 503 
 when 127000 then 504 
 when 137602 then 505 
 when 286716 then 506 
 when 252760 then 507 
 when 23940 then 508 
 when 129502 then 509 
 when 129975 then 510 
 when 79095 then 511 
 when 120706 then 512 
 when 75116 then 513 
 when 134115 then 514 
 when 158620 then 515 
 when 163767 then 516 
 when 163769 then 517 
 when 172160 then 518 
 when 192893 then 519 
 when 200119 then 520 
 when 217668 then 521 
 when 210649 then 522 
 when 225885 then 523 
 when 249134 then 524 
 when 246328 then 525 
 when 257085 then 526 
 when 262949 then 527 
 when 285037 then 528 
 when 119381 then 529 
 when 163770 then 530 
 when 47987 then 531 
 when 246408 then 532 
 when 23941 then 533 
 when 113571 then 534 
 when 115898 then 535 
 when 122795 then 536 
 when 189550 then 537 
 when 192568 then 538 
 when 132087 then 539 
 when 286721 then 540 
 when 112708 then 541 
 when 48158 then 542 
 when 112780 then 543 
 when 121691 then 544 
 when 48119 then 545 
 when 199113 then 546 
 when 200120 then 547 
 when 198835 then 548 
 when 255466 then 549 
 when 254350 then 550 
 when 284838 then 551 
 when 291781 then 552 
 when 108230 then 553 
 when 168073 then 554 
 when 263038 then 555 
 when 88551 then 556 
 when 115469 then 557 
 when 152857 then 558 
 when 280541 then 559 
 when 105976 then 560 
 when 270054 then 561 
 when 268922 then 562 
 when 303423 then 563 
 when 179505 then 564 
 when 169648 then 565 
 when 130890 then 566 
 when 276841 then 567 
 when 292817 then 568 
 when 87006 then 569 
 when 151222 then 570 
 when 139936 then 571 
 when 162539 then 572 
 when 246331 then 573 
 when 268093 then 574 
 when 246375 then 575 
 when 188699 then 576 
 when 246817 then 577 
 when 226018 then 578 
 when 276850 then 579 
 when 275839 then 580 
 when 290652 then 581 
 when 123816 then 582 
 when 103495 then 583 
 when 131840 then 584 
 when 122734 then 585 
 when 126337 then 586 
 when 131500 then 587 
 when 148090 then 588 
 when 158311 then 589 
 when 246377 then 590 
 when 250504 then 591 
 when 255468 then 592 
 when 256328 then 593 
 when 267380 then 594 
 when 278779 then 595 
 when 283645 then 596 
 when 277968 then 597 
 when 172159 then 598 
 when 246371 then 599 
 when 309315 then 600 
 when 222983 then 601 
 when 117398 then 602 
 when 119049 then 603 
 when 113471 then 604 
 when 168604 then 605 
 when 121668 then 606 
 when 117397 then 607 
 when 99505 then 608 
 when 215735 then 609 
 when 23939 then 610 
 when 147943 then 611 
 when 118049 then 612 
 when 300860 then 613 
 when 271942 then 614 
 when 148567 then 615 
 when 255294 then 616 
 when 300861 then 617 
 when 309302 then 618 
 when 93121 then 619 
 when 122443 then 620 
 when 122445 then 621 
 when 152861 then 622 
 when 152900 then 623 
 when 181405 then 624 
 when 205235 then 625 
 when 113452 then 626 
 when 251814 then 627 
 when 138716 then 628 
 when 269834 then 629 
 when 270053 then 630 
 when 285354 then 631 
 when 16444 then 632 
 when 290651 then 633 
 when 294933 then 634 
 when 288124 then 635 
 when 300863 then 636 
 when 131470 then 637 
 when 131471 then 638 
 when 137158 then 639 
 when 113450 then 640 
 when 152874 then 641 
 when 162594 then 642 
 when 113466 then 643 
 when 213506 then 644 
 when 113455 then 645 
 when 117395 then 646 
 when 113475 then 647 
 when 15130 then 648 
 when 245667 then 649 
 when 266596 then 650 
 when 215430 then 651 
 when 296456 then 652 
 when 298697 then 653 
 when 305631 then 654 
 when 195390 then 655 
 when 296584 then 656 
 when 286285 then 657 
 when 301378 then 658 
 when 305561 then 659 
 when 152048 then 660 
 when 206468 then 661 
 when 127512 then 662 
 when 122447 then 663 
 when 117396 then 664 
 when 120769 then 665 
 when 260515 then 666 
 when 280956 then 667 
 when 293309 then 668 
 when 100929 then 669 
 when 215829 then 670 
 when 206453 then 671 
 when 206469 then 672 
 when 206467 then 673 
 when 266046 then 674 
 when 115899 then 675 
 when 137157 then 676 
 when 247883 then 677 
 when 280259 then 678 
 when 280596 then 679 
 when 116424 then 680 
 when 122796 then 681 
 when 293052 then 682 
 when 305562 then 683 
 when 114629 then 684 
 when 221031 then 685 
 when 23947 then 686 
 when 249711 then 687 
 when 23938 then 688 
 when 266044 then 689 
 when 206455 then 690 
 when 206480 then 691 
 when 222214 then 692 
 when 250710 then 693 
 when 250745 then 694 
 when 276848 then 695 
 when 276840 then 696 
 when 286276 then 697 
 when 286277 then 698 
 when 293305 then 699 
 when 281432 then 700 
 when 293311 then 701 
 when 276247 then 702 
 when 206452 then 703 
 when 127031 then 704 
 when 277063 then 705 
 when 209343 then 706 
 when 193594 then 707 
 when 303688 then 708 
 when 199795 then 709 
 when 253719 then 710 
 when 276232 then 711 
 when 206454 then 712 
 when 278376 then 713 
 when 263972 then 714 
 when 206328 then 715 
 when 247872 then 716 
 when 131325 then 717 
 when 113469 then 718 
 when 252127 then 719 
 when 269029 then 720 
 when 293306 then 721 
 when 200478 then 722 
 when 283987 then 723 
 when 276779 then 724 
 when 141478 then 725 
 when 223048 then 726 
 when 283986 then 727 
 when 215806 then 728 
 when 206263 then 729 
 when 202975 then 730 
 when 90914 then 731 
 when 250733 then 732 
 when 250741 then 733 
 when 276851 then 734 
 when 168522 then 735 
 when 205248 then 736 
 when 204875 then 737 
 when 215807 then 738 
 when 249709 then 739 
 when 264226 then 740 
 when 250753 then 741 
 when 120342 then 742 
 when 7527 then 743 
 when 256238 then 744 
 when 283985 then 745 
 when 206265 then 746 
 when 250703 then 747 
 when 206264 then 748 
 when 149760 then 749 
 when 262979 then 750 
 when 120676 then 751 
 when 222119 then 752 
 when 250726 then 753 
 when 143732 then 754 
 when 206262 then 755 
 when 250711 then 756 
 when 296404 then 757 
 when 201098 then 758 
 when 284650 then 759 
 when 16445 then 760 
 when 202976 then 761 
 when 148207 then 762 
 when 296238 then 763 
 when 250772 then 764 
 when 255292 then 765 
 when 168884 then 766 
 when 107615 then 767 
 when 217400 then 768 
 when 98069 then 769 
 when 151347 then 770 
 when 217100 then 771 
 when 154922 then 772 
 when 255297 then 773 
 when 118075 then 774 
 when 192069 then 775 
 when 188780 then 776 
 when 81634 then 777 
 when 276783 then 778 
 when 192561 then 779 
 when 101227 then 780 
 when 264569 then 781 
 when 103872 then 782 
 when 112365 then 783 
 when 116135 then 784 
 when 147109 then 785 
 when 255291 then 786 
 when 138007 then 787 
 when 242314 then 788 
 when 285134 then 789 
 when 279456 then 790 
 when 232626 then 791 
 when 119915 then 792 
 when 123642 then 793 
 when 120579 then 794 
 when 289710 then 795 
 when 115346 then 796 
 when 262262 then 797 
 when 279443 then 798 
 when 270124 then 799 
 when 120734 then 800 
 when 136892 then 801 
 when 110145 then 802 
 when 164375 then 803 
 when 150549 then 804 
 when 176419 then 805 
 when 159485 then 806 
 when 191718 then 807 
 when 191716 then 808 
 when 275982 then 809 
 when 122520 then 810 
 when 283302 then 811 
 when 284649 then 812 
 when 250769 then 813 
 when 112942 then 814 
 when 205236 then 815 
 when 256195 then 816 
 when 277972 then 817 
 when 287575 then 818 
 when 144680 then 819 
 when 151954 then 820 
 when 159030 then 821 
 when 175296 then 822 
 when 193448 then 823 
 when 195392 then 824 
 when 197634 then 825 
 when 206005 then 826 
 when 209004 then 827 
 when 217397 then 828 
 when 193214 then 829 
 when 217402 then 830 
 when 196811 then 831 
 when 208932 then 832 
 when 289474 then 833 
 when 81596 then 834 
 when 297715 then 835 
 when 307684 then 836 
 when 279549 then 837 
 when 250774 then 838 
 when 302961 then 839 
 when 204914 then 840 
 when 297859 then 841 
 when 39729 then 842 
 when 221021 then 843 
 when 247732 then 844 
 when 279551 then 845 
 when 268530 then 846 
 when 289448 then 847 
 when 289436 then 848 
 when 112060 then 849 
 when 173423 then 850 
 when 173424 then 851 
 when 159470 then 852 
 when 181821 then 853 
 when 184317 then 854 
 when 147944 then 855 
 when 193206 then 856 
 when 193940 then 857 
 when 191717 then 858 
 when 191719 then 859 
 when 191721 then 860 
 when 202860 then 861 
 when 207039 then 862 
 when 203170 then 863 
 when 207108 then 864 
 when 208958 then 865 
 when 204808 then 866 
 when 208957 then 867 
 when 208934 then 868 
 when 209441 then 869 
 when 211037 then 870 
 when 220310 then 871 
 when 217396 then 872 
 when 220234 then 873 
 when 222290 then 874 
 when 247970 then 875 
 when 247972 then 876 
 when 255414 then 877 
 when 268155 then 878 
 when 103427 then 879 
 when 287038 then 880 
 when 196526 then 881 
 when 207041 then 882 
 when 208754 then 883 
 when 214143 then 884 
 when 293302 then 885 
 when 284625 then 886 
 when 262963 then 887 
 when 262974 then 888 
 when 289730 then 889 
 when 263970 then 890 
 when 302264 then 891 
 when 302960 then 892 
 when 290405 then 893 
 when 302969 then 894 
 when 302970 then 895 
 when 302966 then 896 
 when 290426 then 897 
 when 290421 then 898 
 when 302964 then 899 
 when 302963 then 900 
 when 179445 then 901 
 when 218218 then 902 
 when 247547 then 903 
 when 277784 then 904 
 when 277919 then 905 
 when 291085 then 906 
 when 289739 then 907 
 when 272159 then 908 
 when 268552 then 909 
 when 162860 then 910 
 when 173421 then 911 
 when 178878 then 912 
 when 178879 then 913 
 when 173389 then 914 
 when 169418 then 915 
 when 191715 then 916 
 when 191714 then 917 
 when 179685 then 918 
 when 191713 then 919 
 when 193768 then 920 
 when 193220 then 921 
 when 193767 then 922 
 when 193218 then 923 
 when 193224 then 924 
 when 193219 then 925 
 when 196525 then 926 
 when 193221 then 927 
 when 196163 then 928 
 when 195452 then 929 
 when 195453 then 930 
 when 186675 then 931 
 when 205625 then 932 
 when 203570 then 933 
 when 206018 then 934 
 when 204806 then 935 
 when 208955 then 936 
 when 209442 then 937 
 when 209626 then 938 
 when 217406 then 939 
 when 217405 then 940 
 when 217276 then 941 
 when 223186 then 942 
 when 217399 then 943 
 when 291096 then 944 
 when 178883 then 945 
 when 191720 then 946 
 when 193205 then 947 
 when 226053 then 948 
 when 247977 then 949 
 when 121248 then 950 
 when 219791 then 951 
 when 302266 then 952 
 when 242374 then 953 
 when 276849 then 954 
 when 297862 then 955 
 when 284624 then 956 
 when 242395 then 957 
 when 280959 then 958 
 when 280961 then 959 
 when 280016 then 960 
 when 280958 then 961 
 when 286232 then 962 
 when 293045 then 963 
 when 285769 then 964 
 when 299177 then 965 
 when 268549 then 966 
 when 279553 then 967 
 when 224194 then 968 
 when 303866 then 969 
 when 172711 then 970 
 when 178669 then 971 
 when 178880 then 972 
 when 186674 then 973 
 when 186673 then 974 
 when 179686 then 975 
 when 193223 then 976 
 when 195699 then 977 
 when 188455 then 978 
 when 195698 then 979 
 when 208743 then 980 
 when 208753 then 981 
 when 211975 then 982 
 when 208482 then 983 
 when 208956 then 984 
 when 222455 then 985 
 when 217275 then 986 
 when 250871 then 987 
 when 280967 then 988 
 when 293298 then 989 
 when 293299 then 990 
 when 301377 then 991 
 when 186676 then 992 
 when 193222 then 993 
 when 217407 then 994 
 when 168718 then 995 
 when 246941 then 996 
 when 155884 then 997 
 when 70304 then 998 
 when 86844 then 999 
 when 92760 then 1000 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (283411,298434,281486,293144,289734,298681,287949,191697,189567,162540,249453,193375,168069,168070,170724,141427,155227,155229,155228,168068,168071,188991,189589,189787,144265,162541,268154,191500,189580,197445,217128,289719,289714,215964,217129,253368,264484,191499,219792,193408,227545,214489,217212,246380,188134,277967,262983,181408,214889,246384,246403,246407,291472,218468,138436,138438,165464,205360,152843,152845,209942,218178,217905,268755,138432,201609,205173,202476,201657,138431,138434,250203,250200,264644,283475,222100,267937,251088,228147,228144,228141,263215,253555,89606,207504,282862,222482,222333,207474,207505,216276,260512,277237,277234,250687,222485,280745,278752,217904,275836,287890,263211,278754,301548,201655,282227,170821,247846,210846,189594,228150,278753,278755,305651,300611,308275,201650,196812,208933,278367,201674,303755,209601,198548,250397,277235,252130,151846,193386,201654,201651,201652,210121,283392,210635,298167,277062,297384,299070,289116,289117,175432,15129,217649,155226,179687,206179,148343,285113,298165,285431,251882,164239,144144,149189,138435,204907,264091,206457,297582,153211,165466,206670,152842,282761,201653,162542,247848,252883,206460,170725,170723,293051,301850,298961,277966,282760,282285,138437,152854,207091,207092,205179,196302,205664,271030,271312,155230,193230,165470,228095,202810,161617,214887,289737,206466,271313,198217,152849,196303,138433,217768,220209,268663,233710,303799,161216,204908,175958,206456,277970,289677,289679,218104,247847,277239,289695,201710,302194,280000,280841,291634,203393,203323,267507,274250,286482,215561,219943,261953,261985,206461,250716,145597,263040,179265,209440,256250,275904,206464,279691,303580,218177,202845,222478,249450,246991,245230,255173,260776,249582,251036,218176,250204,263864,283415,290906,292810,262972,198667,189449,218505,206330,271308,276309,218175,218179,220298,251881,263829,263367,277236,289884,202846,209505,216504,250205,247442,279438,206463,303745,296697,173214,206437,176103,264483,277238,277240,285139,246436,283943,283942,166588,225817,302950,293485,217242,89297,162546,162544,277982,277978,159446,182571,175868,161619,262985,262967,279773,277985,215820,246435,248245,260511,161513,198663,277984,279778,279451,250649,271311,167796,159445,198664,198665,181370,279439,198666,262984,297430,249468,262952,277983,249470,249467,89610,302968,175138,247885,279776,279777,206470,262957,89299,206471,222120,262958,262959,262962,250831,267283,282992,277976,301227,277977,262449,250757,262966,246428,208907,301228,267284,279692,249471,249472,249474,255633,276248,210644,249473,255635,296377,289702,283941,284839,279452,297425,263257,262393,252962,16344,262396,262395,255636,170687,152691,77821,133210,152694,123538,157927,179487,249851,217916,282168,92454,148134,71050,277781,126635,198832,213381,213380,216928,79756,202779,277941,125460,111737,125108,149613,205253,202782,262948,279326,70300,119542,113481,113490,86578,114111,116423,118138,170697,175615,94966,285809,95789,123105,78406,79229,115921,158537,170682,181371,204074,48126,211036,217217,214888,215812,64020,134509,195486,89614,147942,260980,267905,114838,291094,291168,204050,56316,288154,103823,79755,86480,86560,87024,118320,163768,191731,195484,217906,219944,47985,251969,266700,262986,131401,189701,210647,264694,121353,7562,121689,217903,202783,87888,133695,85710,116293,120430,135513,95332,129534,132580,138447,155772,47992,157716,170661,183755,199042,206669,205240,249691,251526,208034,105742,111008,107091,89696,127000,137602,286716,252760,23940,129502,129975,79095,120706,75116,134115,158620,163767,163769,172160,192893,200119,217668,210649,225885,249134,246328,257085,262949,285037,119381,163770,47987,246408,23941,113571,115898,122795,189550,192568,132087,286721,112708,48158,112780,121691,48119,199113,200120,198835,255466,254350,284838,291781,108230,168073,263038,88551,115469,152857,280541,105976,270054,268922,303423,179505,169648,130890,276841,292817,87006,151222,139936,162539,246331,268093,246375,188699,246817,226018,276850,275839,290652,123816,103495,131840,122734,126337,131500,148090,158311,246377,250504,255468,256328,267380,278779,283645,277968,172159,246371,309315,222983,117398,119049,113471,168604,121668,117397,99505,215735,23939,147943,118049,300860,271942,148567,255294,300861,309302,93121,122443,122445,152861,152900,181405,205235,113452,251814,138716,269834,270053,285354,16444,290651,294933,288124,300863,131470,131471,137158,113450,152874,162594,113466,213506,113455,117395,113475,15130,245667,266596,215430,296456,298697,305631,195390,296584,286285,301378,305561,152048,206468,127512,122447,117396,120769,260515,280956,293309,100929,215829,206453,206469,206467,266046,115899,137157,247883,280259,280596,116424,122796,293052,305562,114629,221031,23947,249711,23938,266044,206455,206480,222214,250710,250745,276848,276840,286276,286277,293305,281432,293311,276247,206452,127031,277063,209343,193594,303688,199795,253719,276232,206454,278376,263972,206328,247872,131325,113469,252127,269029,293306,200478,283987,276779,141478,223048,283986,215806,206263,202975,90914,250733,250741,276851,168522,205248,204875,215807,249709,264226,250753,120342,7527,256238,283985,206265,250703,206264,149760,262979,120676,222119,250726,143732,206262,250711,296404,201098,284650,16445,202976,148207,296238,250772,255292,168884,107615,217400,98069,151347,217100,154922,255297,118075,192069,188780,81634,276783,192561,101227,264569,103872,112365,116135,147109,255291,138007,242314,285134,279456,232626,119915,123642,120579,289710,115346,262262,279443,270124,120734,136892,110145,164375,150549,176419,159485,191718,191716,275982,122520,283302,284649,250769,112942,205236,256195,277972,287575,144680,151954,159030,175296,193448,195392,197634,206005,209004,217397,193214,217402,196811,208932,289474,81596,297715,307684,279549,250774,302961,204914,297859,39729,221021,247732,279551,268530,289448,289436,112060,173423,173424,159470,181821,184317,147944,193206,193940,191717,191719,191721,202860,207039,203170,207108,208958,204808,208957,208934,209441,211037,220310,217396,220234,222290,247970,247972,255414,268155,103427,287038,196526,207041,208754,214143,293302,284625,262963,262974,289730,263970,302264,302960,290405,302969,302970,302966,290426,290421,302964,302963,179445,218218,247547,277784,277919,291085,289739,272159,268552,162860,173421,178878,178879,173389,169418,191715,191714,179685,191713,193768,193220,193767,193218,193224,193219,196525,193221,196163,195452,195453,186675,205625,203570,206018,204806,208955,209442,209626,217406,217405,217276,223186,217399,291096,178883,191720,193205,226053,247977,121248,219791,302266,242374,276849,297862,284624,242395,280959,280961,280016,280958,286232,293045,285769,299177,268549,279553,224194,303866,172711,178669,178880,186674,186673,179686,193223,195699,188455,195698,208743,208753,211975,208482,208956,222455,217275,250871,280967,293298,293299,301377,186676,193222,217407,168718,246941,155884,70304,86844,92760)
 
 
  and ltrim(rtrim(lower(a.brand))) = 'federal ammunition'
 
 group by a.style_id 
  order by  instock desc, ranking asc
getSideDepts (Datasource=, Time=0ms, Records=1) in E:\inetpub\wwwroot\search_sidenav.cfm @ 14:36:42.042
select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc
getSideBrands (Datasource=, Time=0ms, Records=1) in E:\inetpub\wwwroot\search_sidenav.cfm @ 14:36:42.042
select distinct brand from mysearch
  order by brand asc
getSideCaliber (Datasource=, Time=0ms, Records=1) in E:\inetpub\wwwroot\search_sidenav.cfm @ 14:36:42.042
select distinct of3 from mysearch
  order by of3 asc
GetProducts (Datasource=celerantsql, Time=18ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =252760 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END
GetPrice (Datasource=celerantsql, Time=15ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=252760 and e.store_id =10 group by a.style_id order by a.style_id
check_qoh (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 252760 and e.store_id = 10 
											group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:36:42.042
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 252760 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=16ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 252760

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
Select distinct * from tb_web_taxonomy where dept = 'Ammo' and typ='EMPTY' and site = 'sportsman'
get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
Select web_url, typ from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'
get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='357 Sig' and subtyp_2='EMPTY' and site = 'sportsman'
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select * from tb_product_reviews 
												where style_id=252760  
												and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=252760
												and status='A' 
												and site = 'sportsman'
GetProducts (Datasource=celerantsql, Time=31ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
SELECT 
					a.style_id,	c.price as min_price,	c.sugg_price as max_price, min(c.wholesale_price) as vipprice,	max(of2) as of2,	max(of4) as of4,	max(of5) as of5,	max(of6) as of6, max(of8) as of8,	max(of9) as of9,	max(of12) as of12,	max(qc) as qc,	max(qoh) as qoh,	a.style,	a.web_style,	(a.description) as web_desc,	(a.web_desc) as web_description,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,	max(a.web_long_desc) as web_long_desc,	max(a.is_firearm) as is_firearm,	max(a.non_invt) as non_invt,	avg(c.price / case when of9='' or of9 is null then 1 else of9 end) as round,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END as brand,	MAX(c.sugg_price) AS max_sugg_price
					FROM
					tb_styles a WITH (NOLOCK)
					INNER JOIN dbo.tb_inet_names z WITH (NOLOCK) ON (a.brand = z.orig_text)
					INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
					INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
					INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
					INNER JOIN dbo.tb_web_taxonomy e WITH (NOLOCK) ON (d.web_taxonomy_id = e.web_taxonomy_id)
					WHERE
					c.store_id = 10 AND a.web_product = 'Y' AND a.picture_id IS NOT NULL and z.field_name='BRAND' and a.style_id =268922 and e.site = 'sportsman' and e.dept<>'California Guns'

					GROUP BY
					a.style_id,	c.price,	c.sugg_price,	a.style,	a.web_style,	a.description,	a.web_desc,	a.picture_id,   e.dept,   e.typ,   e.subtyp_1,   e.subtyp_2,   e.subtyp_3,   e.category_style,   e.web_url,   e.sort_position,CASE WHEN z.web_text IS NULL OR RTRIM(LTRIM(z.web_text)) = '' THEN z.orig_text ELSE z.web_text END
GetPrice (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select a.style_id, min(e.price) as minprice, max(e.price) as maxprice,max(e.sugg_price) as sugg_price1 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id=268922 and e.store_id =10 group by a.style_id order by a.style_id
check_qoh (Datasource=celerantsql, Time=16ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select sum(e.qoh + e.qc) as qoh 
											from tb_skus a WITH (NOLOCK)
											left join tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.sku_id) 
											where a.style_id = 268922 and e.store_id = 10 
											group by a.style_id, e.qc
check_ss_qoh (Datasource=celerantsql, Time=16ms, Records=0) in C:\inetpub\wwwroot\includes\dropship.cfm @ 14:36:42.042
select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 268922 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BERETTA
Parameter #2(cf_sql_varchar) = GLOCK
Parameter #3(cf_sql_varchar) = RUGER
Parameter #4(cf_sql_varchar) = SMITH AND WESSON
Parameter #5(cf_sql_varchar) = LEUPOLD
Parameter #6(cf_sql_varchar) = SPRINGFIELD
Parameter #7(cf_sql_varchar) = THOMPSON CENTER
Parameter #8(cf_sql_varchar) = TIKKA
Parameter #9(cf_sql_varchar) = WALTHER

bulk_price (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select * 
											from tb_mfg_promo.dbo.BULK_ITM_DSCS WITH (NOLOCK)
											where bulk_id = ? and (site is NULL or site = '')
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 268922

get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
Select distinct * from tb_web_taxonomy where dept = 'Ammo' and typ='EMPTY' and site = 'sportsman'
get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
Select web_url, typ from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='EMPTY' and site = 'sportsman'
get_web_url (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
Select web_url, subtyp_1 from tb_web_taxonomy where dept = 'Ammo' and typ='Handgun Ammunition' and subtyp_1='357 Sig' and subtyp_2='EMPTY' and site = 'sportsman'
get_reviews (Datasource=celerantsql, Time=0ms, Records=0) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select * from tb_product_reviews 
												where style_id=268922  
												and status='A' and site = 'sportsman'
get_reviews_average (Datasource=celerantsql, Time=0ms, Records=1) in E:\inetpub\wwwroot\search.cfm @ 14:36:42.042
select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews 
												where style_id=268922
												and status='A' 
												and site = 'sportsman'

Scope Variables

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\websites\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\websites\images\
logdir=E:\websites\logs\
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\websites\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-5054; CFGLOBALS=urltoken%3DCFID%23%3D5054%26CFTOKEN%23%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A41%27%7D%23hitcount%3D76%23timecreated%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A02%27%7D%23cftoken%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23cfid%3D5054%23; LAST_NAME=; FIRST_NAME=; PRD_U=307380%2C3273; CUSTOMER_ID=; USERNAME=; EMAIL=; PASSWORD=; CT_U=91
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/kword/SIG%20P320%20XTEN/brand/federal-ammunition
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/kword/SIG P320 XTEN/brand/federal-ammunition
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
hitcount=76
lastvisit={ts '2024-05-20 14:36:41'}
timecreated={ts '2024-05-20 14:36:02'}
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

Cookie Variables:
CFGLOBALS=urltoken=CFID#=5054&CFTOKEN#=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#lastvisit={ts '2024-05-20 14:36:41'}#hitcount=76#timecreated={ts '2024-05-20 14:36:02'}#cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#cfid=5054#
CFID=5054
CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
CT_U=91
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=307380,3273
USERNAME=

Form Fields:
KWORD=SIG P320 XTEN
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
cs=/category.cfm/CurrentPage/3/brand/RCBS/rebate/buy-green-get-green-314
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_5054_ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
strarray=Array (0)
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

URL Parameters:
CLEARANCE=
DEPT=
DISPLAYCOUNT=18
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
brand=federal-ammunition
kword=SIG P320 XTEN
Debug Rendering Time: 0 ms